package com.shop.search.mapper;

//import com.shop.search.entity.Goods;
import com.base.common.entity.Goods;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

/**
 * @ClassName GoodsMapper
 **/
@Repository
public interface GoodsMapper extends Mapper<Goods> {

    @Select("SELECT\n" +
            "\tCONCAT( CONCAT( MIN( price ), ',' ), MAX( price ) ) \n" +
            "FROM\n" +
            "\ttb_goods \n" +
            "WHERE\n" +
            "\tcategory3_id = #{needId}")
    String getPricePeriod(Long needId);


}
